Med Max gathered the data below for two of the many clinics that it serves—City Clinic and — distributes medical supplies doctors offices throughout Alberta sets its prices
General StudiesGeneralWorked Solution
Med Max distributes medical supplies to doctors’ offices and clinics throughout Alberta. Med Max sets its prices by marking up its cost of goods sold by 5%. For example, if Med Max paid $100 to buy supplies from manufacturers, Med Max would charge its customers $105 to purchase these supplies.
For years, Med Max believed that the 5% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Med Max decided to implement an ABC system to help improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities, as shown below:
Med Max gathered the data below for two of the many clinics that it serves—City Clinic and
County Clinic (both clinics purchased a total quantity of medical supplies that had cost Med
Max $30,000 to buy from its manufacturers):
Required:
1. Compute the total revenue that Med Max would receive from City Clinic and County Clinic.
2. Compute the activity rate for each activity cost pool.
3. Compute the total activity costs that would be assigned to City Clinic and County Clinic.
🔒
Unlock the complete assignment
You are viewing the free preview. Purchase this assignment once to reveal the complete resource.
$9.99 USD
Secure checkout is completed by Stripe.
4. Compute Med Max’s customer margin for City Clinic and County Clinic. ( Hint: Do not overlook the $30,000 cost of goods sold that Med Max incurred serving each clinic.)
5. Describe the purchasing behaviours that are likely to characterize Med Max’s least profitable customers.
SOLUTION
1.Total revenue received:
City General
County General
Cost of goods sold to the hospital (a)
$30,000
$30,000
Markup percentage
× 5%
× 5%
Markup in dollars (b)
$1,500
$1,500
Revenue received from hospitals (a) + (b)
$31,500
$31,500
2.
Activity Rates:
Activity Cost Pool
(a) Estimated Overhead Cost
(b) Expected Activity
(b) Expected Activity
(a) ÷ (b) Activity rate
(a) ÷ (b) Activity rate
Customer deliveries
$400,000
5,000
deliveries
$80.00
per delivery
Manual order processing
$300,000
4,000
orders
$75.00
per manual order
Electronic order processing
$200,000
12,500
orders
$16.00
per electronic order
Line item picking
$500,000
400,000
line items
$1.25
per line item picked
3.
Activity costs are assigned to the two hospitals as follows:
City General:
Activity Cost Pool
(a) Activity Rate
(a) Activity Rate
(b) Activity
(b) Activity
(a) × (b) ABC Cost
Customer deliveries
$80.00
per delivery
10
deliveries
$ 800
Manual order processing
$75.00
per order
0
orders
0
Electronic order processing
$16.00
per order
10
orders
160
Line item picking
$1.25
per line item
100
line items
125
Total activity costs
$1,085
County General:
Activity Cost Pool
(a) Activity Rate
(a) Activity Rate
(b) Activity
(b) Activity
(a) × (b) ABC Cost
Customer deliveries
$80.00
per delivery
20
deliveries
$1,600
Manual order processing
$75.00
per order
40
orders
3,000
Electronic order processing
$16.00
per order
0
orders
0
Line item picking
$1.25
per line item
260
line items
325
Total activity costs
$4,925
4.
Customer margins for the two hospitals:
City General
County General
Sales
$31,500
$31,500
Cost of goods sold
30,000
30,000
Gross margin
1,500
1,500
Customer deliveries
800
1,600
Manual order processing
0
3,000
Electronic order processing
160
0
Line item picking
125
325
Total activity costs
1,085
4,925
Customer margin
$ 415
$(3,425)
5.
Hospitals that require frequent deliveries, place a high volume of manual orders, and order many line items are likely to be unprofitable.